<template>
	<view>
		<view class="uni-header">
			<view class="uni-group">
				<view class="uni-title"></view>
				<view class="uni-sub-title"></view>
			</view>
			<view class="uni-group">
				<input class="uni-search" type="text" v-model="query" @confirm="search"
					placeholder="请输入搜索内容,如商品名称、商品类别或非遗传承人" />
				<button class="uni-button" type="default" size="mini" @click="search">搜索</button>
				<button class="uni-button" type="default" size="mini" @click="navigateTo('./add')">新增</button>
				<button class="uni-button" type="default" size="mini" :disabled="!selectedIndexs.length"
					@click="delTable">批量删除</button>
				<download-excel class="hide-on-phone" :fields="exportExcel.fields" :data="exportExcelData"
					:type="exportExcel.type" :name="exportExcel.filename">
					<button class="uni-button" type="primary" size="mini">导出 Excel</button>
				</download-excel>
			</view>
		</view>
		<view class="uni-container">
			<unicloud-db ref="merchantDB" v-slot:default="{data, loading, error, options}" loadtime="manual"
				collection="intangible_merchant" :where="merchantWhere" @load="onMerchantLoaded" :getone="true">

				<unicloud-db ref="udb" :collection="collectionList"
					field="category_id,master_id,goods_sn,name,price,original_price,discount,producing_area,keywords,goods_desc,goods_thumb,sales_volume,remain_count,comment_count,rating,is_real,is_on_sale,is_best,is_on_blockchain,is_hot,type,add_date,last_modify_date,seller_note"
					:where="where" page-data="replace" :orderby="orderby" :getcount="true" :page-size="options.pageSize"
					:page-current="options.pageCurrent" v-slot:default="{data,pagination,loading,error,options}"
					:options="options" loadtime="manual" @load="onqueryload">
					<uni-table ref="table" :loading="loading" :emptyText="error.message || '没有更多数据'" border stripe
						type="selection" @selection-change="selectionChange">
						<uni-tr>
							<uni-th align="center" filter-type="search"
								@filter-change="filterChange($event, 'goods_sn')" sortable
								@sort-change="sortChange($event, 'goods_sn')">货号</uni-th>
							<uni-th align="center" filter-type="search" @filter-change="filterChange($event, 'name')"
								sortable @sort-change="sortChange($event, 'name')">名称</uni-th>
							<uni-th align="center" filter-type="search"
								@filter-change="filterChange($event, 'category_name')" sortable
								@sort-change="sortChange($event, 'category_name')">商品类别</uni-th>
							<uni-th align="center" filter-type="search"
								@filter-change="filterChange($event, 'goods_thumb')" sortable
								@sort-change="sortChange($event, 'goods_thumb')">缩略图</uni-th>
							<uni-th align="center" filter-type="search"
								@filter-change="filterChange($event, 'master_name')" sortable
								@sort-change="sortChange($event, 'master_name')">非遗传承人</uni-th>
							<uni-th align="center" filter-type="range" @filter-change="filterChange($event, 'price')"
								sortable @sort-change="sortChange($event, 'price')">商品价格(元)</uni-th>
							<uni-th align="center" filter-type="range"
								@filter-change="filterChange($event, 'original_price')" sortable
								@sort-change="sortChange($event, 'original_price')">原始价格(元)</uni-th>
							<uni-th align="center" filter-type="range" @filter-change="filterChange($event, 'discount')"
								sortable @sort-change="sortChange($event, 'discount')">折扣</uni-th>
							<uni-th align="center" filter-type="search"
								@filter-change="filterChange($event, 'producing_area')" sortable
								@sort-change="sortChange($event, 'producing_area')">产地</uni-th>
							<uni-th align="center" filter-type="search"
								@filter-change="filterChange($event, 'keywords')" sortable
								@sort-change="sortChange($event, 'keywords')">关键字</uni-th>
							<uni-th align="center" filter-type="range"
								@filter-change="filterChange($event, 'sales_volume')" sortable
								@sort-change="sortChange($event, 'sales_volume')">销量</uni-th>
							<uni-th align="center" filter-type="range" @filter-change="filterChange($event, 'rating')"
								sortable @sort-change="sortChange($event, 'rating')">商品评分</uni-th>
							<uni-th align="center" sortable @sort-change="sortChange($event, 'is_real')">是否实物</uni-th>

							<uni-th align="center" filter-type="range"
								@filter-change="filterChange($event, 'remain_count')" sortable
								@sort-change="sortChange($event, 'remain_count')">库存数量</uni-th>
							<!-- 							<uni-th align="center" filter-type="range"
								@filter-change="filterChange($event, 'month_sell_count')" sortable
								@sort-change="sortChange($event, 'month_sell_count')">月销量</uni-th>
							<uni-th align="center" filter-type="range"
								@filter-change="filterChange($event, 'total_sell_count')" sortable
								@sort-change="sortChange($event, 'total_sell_count')">总销量</uni-th> -->
							<uni-th align="center" sortable
								@sort-change="sortChange($event, 'is_on_sale')">是否上架</uni-th>
							<uni-th align="center" sortable
								@sort-change="sortChange($event, 'is_on_blockchain')">是否上链</uni-th>
							<uni-th align="center" sortable @sort-change="sortChange($event, 'is_best')">是否精品</uni-th>

							<uni-th align="center" sortable @sort-change="sortChange($event, 'is_hot')">是否热销</uni-th>
							<uni-th align="center" filter-type="timestamp"
								@filter-change="filterChange($event, 'add_date')" sortable
								@sort-change="sortChange($event, 'add_date')">上架日期</uni-th>
							<uni-th align="center" filter-type="timestamp"
								@filter-change="filterChange($event, 'last_modify_date')" sortable
								@sort-change="sortChange($event, 'last_modify_date')">最后修改日期</uni-th>
							<uni-th align="center" filter-type="search"
								@filter-change="filterChange($event, 'seller_note')" sortable
								@sort-change="sortChange($event, 'seller_note')">商家备注</uni-th>
							<uni-th align="center">操作</uni-th>
						</uni-tr>
						<uni-tr v-for="(item,index) in data" :key="index">
							<uni-td align="center">{{item.goods_sn}}</uni-td>
							<uni-td align="center">{{item.name}}</uni-td>
							<uni-td
								align="center">{{item.category_id && item.category_id[0] ? item.category_id[0].category_name : '无'}}</uni-td>
							<uni-td align="center">
								<image :src="item.goods_thumb" style="width: 100px; height: 100px;"></image>
							</uni-td>
							<uni-td
								align="center">{{item.master_id && item.master_id[0] ? item.master_id[0].master_name : '无'}}</uni-td>
							<uni-td align="center">{{item.price}}</uni-td>
							<uni-td align="center">{{item.original_price || '无'}}</uni-td>
							<uni-td
								align="center">{{item.discount ? (item.discount * 100).toFixed(1) + '%' : '无'}}</uni-td>
							<uni-td align="center">{{item.producing_area ? item.producing_area.text : '无'}}</uni-td>
							<uni-td align="center">{{item.keywords || '无'}}</uni-td>
							<uni-td align="center">{{item.sales_volume || '无'}}</uni-td>
							<uni-td align="center">{{item.rating ? item.rating.toFixed(1) + '分' : '无'}}</uni-td>
							<uni-td
								align="center">{{item.is_real === true ? '✅' : item.is_real === false ? '❌' : '无'}}</uni-td>

							<uni-td align="center">{{item.remain_count}}</uni-td>
							<!-- 							<uni-td align="center">{{item.month_sell_count}}</uni-td>
							<uni-td align="center">{{item.total_sell_count}}</uni-td> -->
							<uni-td align="center">{{item.is_on_sale == true ? '✅' : '❌'}}</uni-td>
							<uni-td align="center">{{item.is_on_blockchain == true ? '✅' : '❌'}}</uni-td>
							<uni-td align="center">{{item.is_best == true ? '✅' : '❌'}}</uni-td>
							<uni-td align="center">{{item.is_hot == true ? '✅' : '❌'}}</uni-td>
							<uni-td align="center">
								<uni-dateformat :threshold="[0, 0]" :date="item.add_date"></uni-dateformat>
							</uni-td>
							<uni-td align="center">
								<uni-dateformat :threshold="[0, 0]" :date="item.last_modify_date"></uni-dateformat>
							</uni-td>
							<uni-td align="center">{{item.seller_note}}</uni-td>
							<uni-td align="center">
								<view class="uni-group">
									<button @click="navigateTo('./edit?id='+item._id, false)" class="uni-button"
										size="mini" type="primary">修改</button>
									<button @click="confirmDelete(item._id)" class="uni-button" size="mini"
										type="warn">删除</button>
								</view>
							</uni-td>
						</uni-tr>
					</uni-table>
					<view class="uni-pagination-box">
						<uni-pagination show-icon :page-size="pagination.size" v-model="pagination.current"
							:total="pagination.count" @change="onPageChanged" />
					</view>
				</unicloud-db>

			</unicloud-db>


		</view>
	</view>
</template>

<script>
	import {
		enumConverter,
		filterToWhere
	} from '../../js_sdk/validator/opendb-mall-goods.js';

	const db = uniCloud.database()
	// 表查询配置
	const dbOrderBy = '' // 排序字段
	const dbSearchFields = ['name', 'category_id.category_name',
		'master_id.master_name'] // 模糊搜索字段，支持模糊搜索的字段列表。联表查询格式: 主表字段名.副表字段名，例如用户表关联角色表 role.role_name
	// 分页配置
	const pageSize = 20
	const pageCurrent = 1

	const orderByMapping = {
		"ascending": "asc",
		"descending": "desc"
	}

	export default {
		data() {
			return {
				collectionList: [
					db.collection('opendb-mall-goods').getTemp(),
					db.collection("opendb-mall-categories").field("_id,name as category_name").getTemp(),
					db.collection("intangible_master").field("_id,name as master_name").getTemp()
				],
				query: '',
				orderby: dbOrderBy,
				orderByFieldName: "",
				selectedIndexs: [],
				options: {
					pageSize,
					pageCurrent,
					filterData: {},
					...enumConverter
				},
				imageStyles: {
					width: 64,
					height: 64
				},
				exportExcel: {
					"filename": "opendb-mall-goods.xls",
					"type": "xls",
					"fields": {
						"类别ID": "category_id",
						"非遗传承人ID": "master_id",
						"货号": "goods_sn",
						"名称": "name",
						"价格": "price",
						"原始价格": "original_price",
						"折扣": "discount",
						"产地": "producing_area",
						"关键字": "keywords",
						"详细描述": "goods_desc",
						"缩略图地址": "goods_thumb",
						"销量": "sales_volume",
						"库存数量": "remain_count",
						"评论数": "comment_count",
						"商品评分": "rating",
						"是否实物": "is_real",
						"是否上架": "is_on_sale",
						"是否精品": "is_best",
						"是否上链": "is_on_blockchain",
						"是否热销": "is_hot",
						"上架日期": "add_date",
						"最后修改时间": "last_modify_date",
						"卖家备注": "seller_note"
					}
				},
				exportExcelData: [],
				where: "",
				merchantWhere: '',

			}
		},
		onLoad() {
			this._filter = {}
			this.merchantWhere = "owner_id == '" + uniCloud.getCurrentUserInfo().uid + "'"
			// console.log(999999,this.merchantWhere)

		},
		onReady() {
			this.$refs.merchantDB.loadData()
		},
		methods: {
			onMerchantLoaded(data) {
				if (data) {
					this.where = `merchant_id == '${data._id}'`;
					// 如果需要手动刷新商品数据
					this.$nextTick(() => {
						if (this.$refs.udb) {
							this.$refs.udb.loadData()
						}
					});
				}
			},
			onqueryload(data) {
				this.exportExcelData = data
			},
			getWhere() {
				const query = this.query.trim()
				if (!query) {
					return ''
				}
				const queryRe = new RegExp(query, 'i')
				return dbSearchFields.map(name => queryRe + '.test(' + name + ')').join(' || ')
			},
			search() {
				const newWhere = this.getWhere()
				this.where = (this.where + " && " + newWhere)
				// console.log(1111111111111,this.where)
				this.$nextTick(() => {
					this.loadData()
				})
			},
			loadData(clear = true) {
				this.$refs.udb.loadData({
					clear
				})
			},
			onPageChanged(e) {
				this.selectedIndexs.length = 0
				this.$refs.table.clearSelection()
				this.$refs.udb.loadData({
					current: e.current
				})
			},
			navigateTo(url, clear) {
				// clear 表示刷新列表时是否清除页码，true 表示刷新并回到列表第 1 页，默认为 true
				uni.navigateTo({
					url,
					events: {
						refreshData: () => {
							this.loadData(clear)
						}
					}
				})
			},
			// 多选处理
			selectedItems() {
				var dataList = this.$refs.udb.dataList
				return this.selectedIndexs.map(i => dataList[i]._id)
			},
			// 批量删除
			delTable() {
				this.$refs.udb.remove(this.selectedItems(), {
					success: (res) => {
						this.$refs.table.clearSelection()
					}
				})
			},
			// 多选
			selectionChange(e) {
				this.selectedIndexs = e.detail.index
			},
			confirmDelete(id) {
				this.$refs.udb.remove(id, {
					success: (res) => {
						this.$refs.table.clearSelection()
					}
				})
			},
			sortChange(e, name) {
				this.orderByFieldName = name;
				if (e.order) {
					this.orderby = name + ' ' + orderByMapping[e.order]
				} else {
					this.orderby = ''
				}
				this.$refs.table.clearSelection()
				this.$nextTick(() => {
					this.$refs.udb.loadData()
				})
			},
			filterChange(e, name) {
				this._filter[name] = {
					type: e.filterType,
					value: e.filter
				}
				let newWhere = filterToWhere(this._filter, db.command)
				if (Object.keys(newWhere).length) {
					this.where = (this.where + " && " + newWhere)
				} else {
					this.where = ''
				}
				this.$nextTick(() => {
					this.$refs.udb.loadData()
				})
			}
		}
	}
</script>

<style>
</style>